Data Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	21
Number of observations	1060708
Missing cells	32058
Missing cells (%)	0.1%
Duplicate rows	88323
Duplicate rows (%)	8.3%
Total size in memory	536.6 MiB
Average record size in memory	530.4 B

Variable types

Numeric	14
DateTime	3
Categorical	2
Text	2

Alerts

Dataset has 88323 (8.3%) duplicate rows	Duplicates
`Breadth` is highly overall correlated with `Draught` and 1 other fields	High correlation
`COG` is highly overall correlated with `TH`	High correlation
`Draught` is highly overall correlated with `Breadth` and 1 other fields	High correlation
`EndLatitude` is highly overall correlated with `EndLongitude` and 6 other fields	High correlation
`EndLongitude` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`EndPort` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`Latitude` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`Length` is highly overall correlated with `Breadth` and 1 other fields	High correlation
`Longitude` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`StartLatitude` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`StartLongitude` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`StartPort` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`TH` is highly overall correlated with `COG`	High correlation
`Draught` has 16270 (1.5%) missing values	Missing
`Length` has 10924 (1.0%) zeros	Zeros
`Breadth` has 10924 (1.0%) zeros	Zeros

Reproduction

Analysis started	2025-05-26 20:13:19.387955
Analysis finished	2025-05-26 20:14:10.532240
Duration	51.14 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

TripID
Real number (ℝ)

Distinct	1126
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1086592.4

Minimum	5944
Maximum	2278147
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	5944
5-th percentile	50976
Q1	395842
median	1111606
Q3	1660361
95-th percentile	2183444
Maximum	2278147
Range	2272203
Interquartile range (IQR)	1264519

Descriptive statistics

Standard deviation	687531.89
Coefficient of variation (CV)	0.63274133
Kurtosis	-1.2954519
Mean	1086592.4
Median Absolute Deviation (MAD)	590935
Skewness	0.073698102
Sum	1.1525572 × 10¹²
Variance	4.727001 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
665635	5901	0.6%
1007947	5520	0.5%
665728	5073	0.5%
665659	4206	0.4%
771862	3921	0.4%
183671	3870	0.4%
665761	3732	0.4%
1008001	3729	0.4%
5944	3717	0.4%
183784	3394	0.3%
Other values (1116)	1017645	95.9%

Value	Count	Frequency (%)
5944	3717	0.4%
10257	579	0.1%
19002	41	< 0.1%
19585	1646	0.2%
23834	1241	0.1%
24805	595	0.1%
25124	659	0.1%
28257	1282	0.1%
29139	1255	0.1%
29152	1305	0.1%

Value	Count	Frequency (%)
2278147	518	< 0.1%
2278140	588	0.1%
2278125	528	< 0.1%
2278114	1148	0.1%
2278113	1148	0.1%
2278085	1566	0.1%
2278084	1566	0.1%
2278083	1566	0.1%
2278070	1482	0.1%
2278069	1482	0.1%

StartLatitude
Real number (ℝ)

High correlation

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.002772

Minimum	53.33
Maximum	54.54
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	53.33
5-th percentile	53.52
Q1	53.58
median	54.36
Q3	54.36
95-th percentile	54.36
Maximum	54.54
Range	1.21
Interquartile range (IQR)	0.78

Descriptive statistics

Standard deviation	0.39536968
Coefficient of variation (CV)	0.0073212849
Kurtosis	-1.9299808
Mean	54.002772
Median Absolute Deviation (MAD)	0
Skewness	-0.2043408
Sum	57281172
Variance	0.15631718
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
54.36	571220	53.9%
53.58	222955	21.0%
53.59	61008	5.8%
53.53	45805	4.3%
53.51	34010	3.2%
53.57	29724	2.8%
53.6	25943	2.4%
53.52	17521	1.7%
53.61	8363	0.8%
53.55	5686	0.5%
Other values (18)	38473	3.6%

Value	Count	Frequency (%)
53.33	3169	0.3%
53.34	2535	0.2%
53.5	1285	0.1%
53.51	34010	3.2%
53.52	17521	1.7%
53.53	45805	4.3%
53.54	1289	0.1%
53.55	5686	0.5%
53.56	5654	0.5%
53.57	29724	2.8%

Value	Count	Frequency (%)
54.54	3672	0.3%
54.49	552	0.1%
54.37	1260	0.1%
54.36	571220	53.9%
54.33	3168	0.3%
54.31	1158	0.1%
53.75	976	0.1%
53.74	530	< 0.1%
53.67	4300	0.4%
53.66	411	< 0.1%

StartLongitude
Real number (ℝ)

High correlation

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.4050804

Minimum	8.14
Maximum	10.34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	8.14
5-th percentile	8.5
Q1	8.52
median	10.14
Q3	10.14
95-th percentile	10.14
Maximum	10.34
Range	2.2
Interquartile range (IQR)	1.62

Descriptive statistics

Standard deviation	0.81150576
Coefficient of variation (CV)	0.086283767
Kurtosis	-1.9401815
Mean	9.4050804
Median Absolute Deviation (MAD)	0
Skewness	-0.20234872
Sum	9976044.1
Variance	0.65854161
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
10.14	543986	51.3%
8.52	194761	18.4%
8.53	104786	9.9%
8.57	60852	5.7%
8.51	40838	3.9%
10.13	24050	2.3%
8.54	15232	1.4%
8.5	12688	1.2%
8.15	10967	1.0%
8.49	9064	0.9%
Other values (24)	43484	4.1%

Value	Count	Frequency (%)
8.14	485	< 0.1%
8.15	10967	1.0%
8.16	1298	0.1%
8.19	976	0.1%
8.22	530	< 0.1%
8.36	2156	0.2%
8.37	2144	0.2%
8.38	411	< 0.1%
8.39	984	0.1%
8.4	523	< 0.1%

Value	Count	Frequency (%)
10.34	552	0.1%
10.29	3672	0.3%
10.18	3188	0.3%
10.17	2939	0.3%
10.16	1489	0.1%
10.15	1154	0.1%
10.14	543986	51.3%
10.13	24050	2.3%
8.57	60852	5.7%
8.56	3146	0.3%

StartTime
Date

Distinct	953
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.1 MiB

Minimum	2016-01-13 06:03:00
Maximum	2017-05-26 19:44:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

EndLatitude
Real number (ℝ)

High correlation

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.045262

Minimum	53.47
Maximum	54.64
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	53.47
5-th percentile	53.5
Q1	53.53
median	54.38
Q3	54.53
95-th percentile	54.54
Maximum	54.64
Range	1.17
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.47881511
Coefficient of variation (CV)	0.0088595206
Kurtosis	-1.9291169
Mean	54.045262
Median Absolute Deviation (MAD)	0.16
Skewness	-0.15909692
Sum	57326241
Variance	0.22926391
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
53.53	248414	23.4%
54.54	223218	21.0%
53.5	120692	11.4%
54.38	97636	9.2%
54.52	56917	5.4%
53.52	44887	4.2%
54.53	44210	4.2%
54.44	42625	4.0%
53.54	37792	3.6%
54.43	30822	2.9%
Other values (19)	113495	10.7%

Value	Count	Frequency (%)
53.47	1291	0.1%
53.48	677	0.1%
53.49	10546	1.0%
53.5	120692	11.4%
53.51	10832	1.0%
53.52	44887	4.2%
53.53	248414	23.4%
53.54	37792	3.6%
53.56	678	0.1%
53.61	2018	0.2%

Value	Count	Frequency (%)
54.64	1646	0.2%
54.59	740	0.1%
54.54	223218	21.0%
54.53	44210	4.2%
54.52	56917	5.4%
54.51	5176	0.5%
54.5	522	< 0.1%
54.47	1282	0.1%
54.46	7698	0.7%
54.45	8806	0.8%

EndLongitude
Real number (ℝ)

High correlation

Distinct	47
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.668992

Minimum	9.5
Maximum	18.92
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	9.5
5-th percentile	9.9
Q1	9.92
median	18.5
Q3	18.6
95-th percentile	18.71
Maximum	18.92
Range	9.42
Interquartile range (IQR)	8.68

Descriptive statistics

Standard deviation	4.3208528
Coefficient of variation (CV)	0.2945569
Kurtosis	-1.9620247
Mean	14.668992
Median Absolute Deviation (MAD)	0.21
Skewness	-0.19134138
Sum	15559517
Variance	18.669769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
9.91	125320	11.8%
18.51	120016	11.3%
18.5	103202	9.7%
9.93	88646	8.4%
9.9	76211	7.2%
9.95	72994	6.9%
18.66	49594	4.7%
18.65	49227	4.6%
18.67	38212	3.6%
18.71	35136	3.3%
Other values (37)	302150	28.5%

Value	Count	Frequency (%)
9.5	1190	0.1%
9.51	661	0.1%
9.54	1196	0.1%
9.55	178	< 0.1%
9.56	644	0.1%
9.73	678	0.1%
9.82	27618	2.6%
9.83	6963	0.7%
9.88	1222	0.1%
9.9	76211	7.2%

Value	Count	Frequency (%)
18.92	1646	0.2%
18.88	740	0.1%
18.83	9886	0.9%
18.82	18777	1.8%
18.81	4884	0.5%
18.75	1501	0.1%
18.72	3778	0.4%
18.71	35136	3.3%
18.7	7901	0.7%
18.68	3372	0.3%

EndTime
Date

Distinct	943
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.1 MiB

Minimum	2016-01-13 14:36:00
Maximum	2017-05-27 22:11:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

StartPort
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	64.9 MiB

KIEL	581030
BREMERHAVEN	479678

Length

Max length	11
Median length	4
Mean length	7.1655705
Min length	4

Characters and Unicode

Total characters	7600578
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BREMERHAVEN
2nd row	BREMERHAVEN
3rd row	BREMERHAVEN
4th row	BREMERHAVEN
5th row	BREMERHAVEN

Common Values

Value	Count	Frequency (%)
KIEL	581030	54.8%
BREMERHAVEN	479678	45.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
kiel	581030	54.8%
bremerhaven	479678	45.2%

Most occurring characters

Value	Count	Frequency (%)
E	2020064	26.6%
R	959356	12.6%
K	581030	7.6%
I	581030	7.6%
L	581030	7.6%
B	479678	6.3%
M	479678	6.3%
H	479678	6.3%
A	479678	6.3%
V	479678	6.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7600578	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	2020064	26.6%
R	959356	12.6%
K	581030	7.6%
I	581030	7.6%
L	581030	7.6%
B	479678	6.3%
M	479678	6.3%
H	479678	6.3%
A	479678	6.3%
V	479678	6.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7600578	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	2020064	26.6%
R	959356	12.6%
K	581030	7.6%
I	581030	7.6%
L	581030	7.6%
B	479678	6.3%
M	479678	6.3%
H	479678	6.3%
A	479678	6.3%
V	479678	6.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7600578	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	2020064	26.6%
R	959356	12.6%
K	581030	7.6%
I	581030	7.6%
L	581030	7.6%
B	479678	6.3%
M	479678	6.3%
H	479678	6.3%
A	479678	6.3%
V	479678	6.3%

EndPort
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	64.2 MiB

GDYNIA	581030
HAMBURG	479678

Length

Max length	7
Median length	6
Mean length	6.4522244
Min length	6

Characters and Unicode

Total characters	6843926
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HAMBURG
2nd row	HAMBURG
3rd row	HAMBURG
4th row	HAMBURG
5th row	HAMBURG

Common Values

Value	Count	Frequency (%)
GDYNIA	581030	54.8%
HAMBURG	479678	45.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
gdynia	581030	54.8%
hamburg	479678	45.2%

Most occurring characters

Value	Count	Frequency (%)
G	1060708	15.5%
A	1060708	15.5%
D	581030	8.5%
Y	581030	8.5%
N	581030	8.5%
I	581030	8.5%
H	479678	7.0%
M	479678	7.0%
B	479678	7.0%
U	479678	7.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6843926	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
G	1060708	15.5%
A	1060708	15.5%
D	581030	8.5%
Y	581030	8.5%
N	581030	8.5%
I	581030	8.5%
H	479678	7.0%
M	479678	7.0%
B	479678	7.0%
U	479678	7.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6843926	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
G	1060708	15.5%
A	1060708	15.5%
D	581030	8.5%
Y	581030	8.5%
N	581030	8.5%
I	581030	8.5%
H	479678	7.0%
M	479678	7.0%
B	479678	7.0%
U	479678	7.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6843926	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
G	1060708	15.5%
A	1060708	15.5%
D	581030	8.5%
Y	581030	8.5%
N	581030	8.5%
I	581030	8.5%
H	479678	7.0%
M	479678	7.0%
B	479678	7.0%
U	479678	7.0%

time
Date

Distinct	414193
Distinct (%)	39.0%
Missing	0
Missing (%)	0.0%
Memory size	8.1 MiB

Minimum	2016-01-13 07:03:00+01:00
Maximum	2017-05-28 00:11:00+02:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

shiptype
Real number (ℝ)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	72.004909

Minimum	0
Maximum	89
Zeros	7224
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0
5-th percentile	70
Q1	70
median	71
Q3	71
95-th percentile	81
Maximum	89
Range	89
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	7.0360096
Coefficient of variation (CV)	0.097715693
Kurtosis	72.035607
Mean	72.004909
Median Absolute Deviation (MAD)	1
Skewness	-7.0245955
Sum	76376183
Variance	49.505431
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
71	456257	43.0%
70	355276	33.5%
79	142274	13.4%
81	65116	6.1%
72	13891	1.3%
80	11569	1.1%
0	7224	0.7%
74	3745	0.4%
73	3627	0.3%
69	1144	0.1%

Value	Count	Frequency (%)
0	7224	0.7%
69	1144	0.1%
70	355276	33.5%
71	456257	43.0%
72	13891	1.3%
73	3627	0.3%
74	3745	0.4%
79	142274	13.4%
80	11569	1.1%
81	65116	6.1%

Value	Count	Frequency (%)
89	585	0.1%
81	65116	6.1%
80	11569	1.1%
79	142274	13.4%
74	3745	0.4%
73	3627	0.3%
72	13891	1.3%
71	456257	43.0%
70	355276	33.5%
69	1144	0.1%

Length
Real number (ℝ)

High correlation Zeros

Distinct	107
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	125.19258

Minimum	0
Maximum	745
Zeros	10924
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0
5-th percentile	68
Q1	88
median	134
Q3	151
95-th percentile	170
Maximum	745
Range	745
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	46.100813
Coefficient of variation (CV)	0.36823919
Kurtosis	19.645539
Mean	125.19258
Median Absolute Deviation (MAD)	32
Skewness	2.2124931
Sum	1.3279277 × 10⁸
Variance	2125.285
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
151	115425	10.9%
134	82214	7.8%
125	68105	6.4%
88	63797	6.0%
68	62288	5.9%
155	59904	5.6%
82	48473	4.6%
168	41015	3.9%
101	39221	3.7%
79	34122	3.2%
Other values (97)	446144	42.1%

Value	Count	Frequency (%)
0	10924	1.0%
45	1760	0.2%
64	250	< 0.1%
65	1362	0.1%
66	1509	0.1%
68	62288	5.9%
70	6114	0.6%
74	9904	0.9%
75	10082	1.0%
78	1	< 0.1%

Value	Count	Frequency (%)
745	73	< 0.1%
666	163	< 0.1%
665	1	< 0.1%
663	593	0.1%
457	19	< 0.1%
399	1716	0.2%
397	1153	0.1%
396	660	0.1%
377	13	< 0.1%
300	1142	0.1%

Breadth
Real number (ℝ)

High correlation Zeros

Distinct	36
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.793328

Minimum	0
Maximum	60
Zeros	10924
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0
5-th percentile	12
Q1	13
median	22
Q3	24
95-th percentile	27
Maximum	60
Range	60
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	6.3733656
Coefficient of variation (CV)	0.32199566
Kurtosis	4.5083339
Mean	19.793328
Median Absolute Deviation (MAD)	3
Skewness	0.52331276
Sum	20994941
Variance	40.619789
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
22	156866	14.8%
12	141817	13.4%
23	141407	13.3%
24	112365	10.6%
13	96755	9.1%
18	70665	6.7%
25	68274	6.4%
26	50806	4.8%
19	38464	3.6%
11	35475	3.3%
Other values (26)	147814	13.9%

Value	Count	Frequency (%)
0	10924	1.0%
8	1760	0.2%
9	637	0.1%
10	3753	0.4%
11	35475	3.3%
12	141817	13.4%
13	96755	9.1%
14	13143	1.2%
15	14038	1.3%
16	12796	1.2%

Value	Count	Frequency (%)
60	1716	0.2%
59	660	0.1%
56	1153	0.1%
48	1142	0.1%
45	85	< 0.1%
42	1071	0.1%
40	3919	0.4%
36	652	0.1%
35	564	0.1%
33	681	0.1%

Draught
Real number (ℝ)

High correlation Missing

Distinct	238
Distinct (%)	< 0.1%
Missing	16270
Missing (%)	1.5%
Infinite	0
Infinite (%)	0.0%
Mean	6.3531713

Minimum	0
Maximum	14
Zeros	50
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0
5-th percentile	2.8
Q1	4.3
median	6.99
Q3	8.1
95-th percentile	9.3
Maximum	14
Range	14
Interquartile range (IQR)	3.8

Descriptive statistics

Standard deviation	2.1817278
Coefficient of variation (CV)	0.34340768
Kurtosis	-1.0945318
Mean	6.3531713
Median Absolute Deviation (MAD)	1.61
Skewness	-0.24484887
Sum	6635493.5
Variance	4.7599364
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.2	62267	5.9%
2.8	56246	5.3%
8.3	30569	2.9%
7.9	21869	2.1%
8.1	20690	2.0%
7.7	20220	1.9%
7.8	20045	1.9%
8.4	19158	1.8%
3.8	16693	1.6%
8	14619	1.4%
Other values (228)	762062	71.8%
(Missing)	16270	1.5%

Value	Count	Frequency (%)
0	50	< 0.1%
0.1	637	0.1%
1.93	1771	0.2%
2.3	1612	0.2%
2.4	3660	0.3%
2.5	1373	0.1%
2.6	7279	0.7%
2.63	41	< 0.1%
2.7	1783	0.2%
2.8	56246	5.3%

Value	Count	Frequency (%)
14	15	< 0.1%
13.23	544	0.1%
11.7	645	0.1%
11.54	1071	0.1%
11.45	551	0.1%
11.4	1223	0.1%
11.24	691	0.1%
11.1	627	0.1%
11	368	< 0.1%
10.98	211	< 0.1%

Latitude
Real number (ℝ)

High correlation

Distinct	273
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.254746

Minimum	53.33
Maximum	56.34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	53.33
5-th percentile	53.56
Q1	53.84
median	54.42
Q3	54.64
95-th percentile	54.89
Maximum	56.34
Range	3.01
Interquartile range (IQR)	0.8

Descriptive statistics

Standard deviation	0.46112175
Coefficient of variation (CV)	0.0084991967
Kurtosis	-1.1461436
Mean	54.254746
Median Absolute Deviation (MAD)	0.44
Skewness	-0.023478134
Sum	57548443
Variance	0.21263327
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
53.87	36524	3.4%
53.84	25419	2.4%
53.98	24948	2.4%
54.53	24948	2.4%
54.41	21658	2.0%
53.54	21377	2.0%
53.86	21117	2.0%
53.85	20259	1.9%
53.83	20080	1.9%
53.97	19608	1.8%
Other values (263)	824770	77.8%

Value	Count	Frequency (%)
53.33	13	< 0.1%
53.34	40	< 0.1%
53.35	29	< 0.1%
53.36	26	< 0.1%
53.37	25	< 0.1%
53.38	27	< 0.1%
53.39	26	< 0.1%
53.4	23	< 0.1%
53.41	24	< 0.1%
53.42	26	< 0.1%

Value	Count	Frequency (%)
56.34	2	< 0.1%
56.33	4	< 0.1%
56.32	4	< 0.1%
56.31	3	< 0.1%
56.3	3	< 0.1%
56.29	12	< 0.1%
56.28	8	< 0.1%
56.27	5	< 0.1%
56.26	5	< 0.1%
56.25	6	< 0.1%

Longitude
Real number (ℝ)

High correlation

Distinct	1285
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.795568

Minimum	2.32
Maximum	20.66
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	2.32
5-th percentile	8.07
Q1	8.84
median	10.63
Q3	13.91
95-th percentile	18.78
Maximum	20.66
Range	18.34
Interquartile range (IQR)	5.07

Descriptive statistics

Standard deviation	3.4893528
Coefficient of variation (CV)	0.29581897
Kurtosis	-0.52727943
Mean	11.795568
Median Absolute Deviation (MAD)	2.16
Skewness	0.83164774
Sum	12511653
Variance	12.175583
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.51	5970	0.6%
8.52	5919	0.6%
8.12	5858	0.6%
8.11	5439	0.5%
9.93	5159	0.5%
9.9	5087	0.5%
9.5	5032	0.5%
8.51	4573	0.4%
9.39	4068	0.4%
9.38	4061	0.4%
Other values (1275)	1009542	95.2%

Value	Count	Frequency (%)
2.32	1	< 0.1%
7.71	2	< 0.1%
7.72	45	< 0.1%
7.73	102	< 0.1%
7.74	99	< 0.1%
7.75	108	< 0.1%
7.76	83	< 0.1%
7.77	83	< 0.1%
7.78	81	< 0.1%
7.79	78	< 0.1%

Value	Count	Frequency (%)
20.66	1	< 0.1%
20.65	3	< 0.1%
20.64	2	< 0.1%
20.63	2	< 0.1%
20.62	6	< 0.1%
20.61	6	< 0.1%
20.6	4	< 0.1%
20.59	6	< 0.1%
20.58	6	< 0.1%
20.57	6	< 0.1%

SOG
Real number (ℝ)

Distinct	227
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.052569

Minimum	0.2
Maximum	73.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0.2
5-th percentile	6.6
Q1	9.9
median	12
Q3	14.5
95-th percentile	17.4
Maximum	73.6
Range	73.4
Interquartile range (IQR)	4.6

Descriptive statistics

Standard deviation	3.491536
Coefficient of variation (CV)	0.28969226
Kurtosis	0.88461558
Mean	12.052569
Median Absolute Deviation (MAD)	2.3
Skewness	-0.45462053
Sum	12784257
Variance	12.190824
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.5	14605	1.4%
10.4	14338	1.4%
10.7	14081	1.3%
10.6	14073	1.3%
11.7	13702	1.3%
10.3	13450	1.3%
11.6	13441	1.3%
11	13198	1.2%
10.9	12878	1.2%
11.4	12670	1.2%
Other values (217)	924272	87.1%

Value	Count	Frequency (%)
0.2	443	< 0.1%
0.3	1912	0.2%
0.4	1615	0.2%
0.5	1232	0.1%
0.6	1093	0.1%
0.7	967	0.1%
0.8	1095	0.1%
0.9	1013	0.1%
1	915	0.1%
1.1	874	0.1%

Value	Count	Frequency (%)
73.6	2	< 0.1%
51.2	1	< 0.1%
22.6	1	< 0.1%
22.5	1	< 0.1%
22.4	2	< 0.1%
22.3	1	< 0.1%
22.2	4	< 0.1%
22.1	4	< 0.1%
22	6	< 0.1%
21.9	5	< 0.1%

COG
Real number (ℝ)

High correlation

Distinct	3602
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	126.98212

Minimum	0
Maximum	378
Zeros	210
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0
5-th percentile	45.9
Q1	82
median	100
Q3	136.3
95-th percentile	314.9
Maximum	378
Range	378
Interquartile range (IQR)	54.3

Descriptive statistics

Standard deviation	77.955041
Coefficient of variation (CV)	0.61390566
Kurtosis	1.1463033
Mean	126.98212
Median Absolute Deviation (MAD)	22.7
Skewness	1.4540593
Sum	1.3469095 × 10⁸
Variance	6076.9884
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90	8874	0.8%
81	8420	0.8%
82	7569	0.7%
89	6461	0.6%
86	6142	0.6%
100	6036	0.6%
85	5864	0.6%
88	5757	0.5%
83	5701	0.5%
87	5569	0.5%
Other values (3592)	994315	93.7%

Value	Count	Frequency (%)
0	210	< 0.1%
0.1	580	0.1%
0.2	32	< 0.1%
0.3	26	< 0.1%
0.4	19	< 0.1%
0.5	37	< 0.1%
0.6	37	< 0.1%
0.7	35	< 0.1%
0.8	37	< 0.1%
0.9	60	< 0.1%

Value	Count	Frequency (%)
378	1	< 0.1%
360	12	< 0.1%
359.9	69	< 0.1%
359.8	41	< 0.1%
359.7	18	< 0.1%
359.6	30	< 0.1%
359.5	34	< 0.1%
359.4	24	< 0.1%
359.3	41	< 0.1%
359.2	22	< 0.1%

TH
Real number (ℝ)

High correlation

Distinct	361
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	131.96787

Minimum	0
Maximum	511
Zeros	623
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0
5-th percentile	47
Q1	82
median	100
Q3	140
95-th percentile	320
Maximum	511
Range	511
Interquartile range (IQR)	58

Descriptive statistics

Standard deviation	88.948972
Coefficient of variation (CV)	0.67401989
Kurtosis	3.3333694
Mean	131.96787
Median Absolute Deviation (MAD)	23
Skewness	1.821028
Sum	1.3997938 × 10⁸
Variance	7911.9196
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
82	25863	2.4%
81	24895	2.3%
90	23223	2.2%
83	23084	2.2%
85	20672	1.9%
84	20368	1.9%
89	18944	1.8%
88	17458	1.6%
86	17427	1.6%
80	17292	1.6%
Other values (351)	851482	80.3%

Value	Count	Frequency (%)
0	623	0.1%
1	556	0.1%
2	479	< 0.1%
3	531	0.1%
4	319	< 0.1%
5	328	< 0.1%
6	282	< 0.1%
7	330	< 0.1%
8	304	< 0.1%
9	229	< 0.1%

Value	Count	Frequency (%)
511	12985	1.2%
359	515	< 0.1%
358	617	0.1%
357	398	< 0.1%
356	506	< 0.1%
355	594	0.1%
354	524	< 0.1%
353	331	< 0.1%
352	312	< 0.1%
351	259	< 0.1%

Destination
Text

Distinct	139
Distinct (%)	< 0.1%
Missing	5898
Missing (%)	0.6%
Memory size	64.9 MiB

Length

Max length	21
Median length	20
Mean length	7.3506679
Min length	2

Characters and Unicode

Total characters	7753558
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	HAMBURG
2nd row	HAMBURG
3rd row	HAMBURG
4th row	HAMBURG
5th row	HAMBURG

Value	Count	Frequency (%)
hamburg	272461	25.8%
gdynia	222145	21.1%
gdansk	159967	15.2%
deham	103184	9.8%
gdynia.via.nok	35601	3.4%
de.ham	34098	3.2%
plgdn	29926	2.8%
finkenwerder	27420	2.6%
gdansk.via.nok	25973	2.5%
debrv.>.deham	21493	2.0%
Other values (119)	122542	11.6%

Most occurring characters

Value	Count	Frequency (%)
A	1077310	13.9%
G	826092	10.7%
D	808213	10.4%
N	683409	8.8%
H	460718	5.9%
M	451050	5.8%
I	427304	5.5%
R	368526	4.8%
K	350211	4.5%
E	327579	4.2%
Other values (36)	1973146	25.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7753558	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	1077310	13.9%
G	826092	10.7%
D	808213	10.4%
N	683409	8.8%
H	460718	5.9%
M	451050	5.8%
I	427304	5.5%
R	368526	4.8%
K	350211	4.5%
E	327579	4.2%
Other values (36)	1973146	25.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7753558	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	1077310	13.9%
G	826092	10.7%
D	808213	10.4%
N	683409	8.8%
H	460718	5.9%
M	451050	5.8%
I	427304	5.5%
R	368526	4.8%
K	350211	4.5%
E	327579	4.2%
Other values (36)	1973146	25.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7753558	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	1077310	13.9%
G	826092	10.7%
D	808213	10.4%
N	683409	8.8%
H	460718	5.9%
M	451050	5.8%
I	427304	5.5%
R	368526	4.8%
K	350211	4.5%
E	327579	4.2%
Other values (36)	1973146	25.4%

AisSourcen
Text

Distinct	223
Distinct (%)	< 0.1%
Missing	9890
Missing (%)	0.9%
Memory size	69.4 MiB

Length

Max length	31
Median length	28
Mean length	11.994004
Min length	2

Characters and Unicode

Total characters	12603515
Distinct characters	30
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	DAIS1.81b.90b.71.71a
2nd row	DAIS1.81b.90b.71.71a
3rd row	DAIS1.81b.90b.71.71a
4th row	DAIS1.81b.90b.71.71a
5th row	DAIS1.81b.90b.71.71a

Value	Count	Frequency (%)
h7001	158252	15.1%
51.71a.h7001.81b	99047	9.4%
71a.h7001.81b	85871	8.2%
71.51.71a.h7001.81b	67024	6.4%
71.71a.h7001.81b	61410	5.8%
71a.h7001	48129	4.6%
71a.h7001.67b	42889	4.1%
71.71a.h7001	40625	3.9%
71.71a.h7001.67b	33854	3.2%
71.71a.67b	33695	3.2%
Other values (213)	380022	36.2%

Most occurring characters

Value	Count	Frequency (%)
1	2823933	22.4%
7	2263859	18.0%
.	2084891	16.5%
0	1722274	13.7%
H	838755	6.7%
a	829979	6.6%
b	682837	5.4%
8	439536	3.5%
5	287020	2.3%
6	226349	1.8%
Other values (20)	404082	3.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12603515	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	2823933	22.4%
7	2263859	18.0%
.	2084891	16.5%
0	1722274	13.7%
H	838755	6.7%
a	829979	6.6%
b	682837	5.4%
8	439536	3.5%
5	287020	2.3%
6	226349	1.8%
Other values (20)	404082	3.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12603515	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	2823933	22.4%
7	2263859	18.0%
.	2084891	16.5%
0	1722274	13.7%
H	838755	6.7%
a	829979	6.6%
b	682837	5.4%
8	439536	3.5%
5	287020	2.3%
6	226349	1.8%
Other values (20)	404082	3.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12603515	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	2823933	22.4%
7	2263859	18.0%
.	2084891	16.5%
0	1722274	13.7%
H	838755	6.7%
a	829979	6.6%
b	682837	5.4%
8	439536	3.5%
5	287020	2.3%
6	226349	1.8%
Other values (20)	404082	3.2%

	Breadth	COG	Draught	EndLatitude	EndLongitude	EndPort	Latitude	Length	Longitude	SOG	StartLatitude	StartLongitude	StartPort	TH	TripID	shiptype
Breadth	1.000	0.013	0.889	0.114	-0.214	0.242	-0.044	0.942	-0.050	0.410	0.044	-0.154	0.242	0.002	-0.019	0.268
COG	0.013	1.000	-0.020	-0.299	-0.298	0.440	-0.370	-0.026	-0.154	0.010	-0.328	-0.311	0.440	0.941	0.007	0.046
Draught	0.889	-0.020	1.000	0.165	-0.110	0.232	0.040	0.900	0.031	0.413	0.155	-0.068	0.232	-0.024	0.013	0.274
EndLatitude	0.114	-0.299	0.165	1.000	0.560	1.000	0.764	0.189	0.751	-0.045	0.821	0.796	1.000	-0.290	-0.013	-0.136
EndLongitude	-0.214	-0.298	-0.110	0.560	1.000	1.000	0.737	-0.103	0.747	-0.263	0.804	0.833	1.000	-0.273	0.015	-0.017
EndPort	0.242	0.440	0.232	1.000	1.000	1.000	1.000	0.260	0.919	0.094	1.000	1.000	1.000	0.397	0.335	0.305
Latitude	-0.044	-0.370	0.040	0.764	0.737	1.000	1.000	0.049	0.781	-0.054	0.814	0.801	1.000	-0.348	-0.012	-0.096
Length	0.942	-0.026	0.900	0.189	-0.103	0.260	0.049	1.000	0.046	0.397	0.181	-0.072	0.260	-0.033	-0.046	0.223
Longitude	-0.050	-0.154	0.031	0.751	0.747	0.919	0.781	0.046	1.000	-0.223	0.815	0.802	0.919	-0.141	-0.011	-0.099
SOG	0.410	0.010	0.413	-0.045	-0.263	0.094	-0.054	0.397	-0.223	1.000	-0.115	-0.205	0.094	-0.012	-0.061	0.163
StartLatitude	0.044	-0.328	0.155	0.821	0.804	1.000	0.814	0.181	0.815	-0.115	1.000	0.812	1.000	-0.309	-0.019	-0.115
StartLongitude	-0.154	-0.311	-0.068	0.796	0.833	1.000	0.801	-0.072	0.802	-0.205	0.812	1.000	1.000	-0.292	0.005	-0.074
StartPort	0.242	0.440	0.232	1.000	1.000	1.000	1.000	0.260	0.919	0.094	1.000	1.000	1.000	0.397	0.335	0.305
TH	0.002	0.941	-0.024	-0.290	-0.273	0.397	-0.348	-0.033	-0.141	-0.012	-0.309	-0.292	0.397	1.000	0.008	0.046
TripID	-0.019	0.007	0.013	-0.013	0.015	0.335	-0.012	-0.046	-0.011	-0.061	-0.019	0.005	0.335	0.008	1.000	0.195
shiptype	0.268	0.046	0.274	-0.136	-0.017	0.305	-0.096	0.223	-0.099	0.163	-0.115	-0.074	0.305	0.046	0.195	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	TripID	StartLatitude	StartLongitude	StartTime	EndLatitude	EndLongitude	EndTime	StartPort	EndPort	time	shiptype	Length	Breadth	Draught	Latitude	Longitude	SOG	COG	TH	Destination	AisSourcen
0	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:07:00+01:00	71	277	42	11.54	53.57	8.53	0.7	331.2	143	HAMBURG	DAIS1.81b.90b.71.71a
1	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:10:00+01:00	71	277	42	11.54	53.57	8.53	1.6	315.3	117	HAMBURG	DAIS1.81b.90b.71.71a
2	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:10:00+01:00	71	277	42	11.54	53.57	8.53	2.8	322.6	100	HAMBURG	DAIS1.81b.90b.71.71a
3	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:12:00+01:00	71	277	42	11.54	53.57	8.53	2.8	286.3	74	HAMBURG	DAIS1.81b.90b.71.71a
4	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:16:00+01:00	71	277	42	11.54	53.57	8.53	4.3	333.1	333	HAMBURG	DAIS1.81b.90b.71.71a
5	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:17:00+01:00	71	277	42	11.54	53.57	8.53	5.2	334.0	333	HAMBURG	51.DAIS1.81b.90b.71.71a
6	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:18:00+01:00	71	277	42	11.54	53.57	8.53	5.7	333.0	333	HAMBURG	51.DAIS1.81b.90b.71.71a
7	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:19:00+01:00	71	277	42	11.54	53.57	8.52	6.3	333.0	333	HAMBURG	51.DAIS1.81b.90b.71.71a
8	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:20:00+01:00	71	277	42	11.54	53.58	8.52	6.8	333.0	333	HAMBURG	51.DAIS1.81b.90b.71.71a
9	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:21:00+01:00	71	277	42	11.54	53.58	8.52	7.1	332.1	333	HAMBURG	51.DAIS1.81b.90b.71.71a

	TripID	StartLatitude	StartLongitude	StartTime	EndLatitude	EndLongitude	EndTime	StartPort	EndPort	time	shiptype	Length	Breadth	Draught	Latitude	Longitude	SOG	COG	TH	Destination	AisSourcen
1060698	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 16:02:00+02:00	70	89	13	4.0	54.50	18.74	7.2	222.0	215	GDANSK	H7001
1060699	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 16:01:00+02:00	70	89	13	4.0	54.50	18.74	7.2	221.6	215	GDANSK	H7001
1060700	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 16:00:00+02:00	70	89	13	4.0	54.50	18.74	7.2	221.5	215	GDANSK	H7001
1060701	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:59:00+02:00	70	89	13	4.0	54.50	18.75	7.2	221.2	215	GDANSK	H7001
1060702	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:58:00+02:00	70	89	13	4.0	54.50	18.75	7.2	220.8	215	GDANSK	H7001
1060703	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:57:00+02:00	70	89	13	4.0	54.51	18.75	7.2	221.0	215	GDANSK	H7001
1060704	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:56:00+02:00	70	89	13	4.0	54.51	18.75	7.2	221.9	215	GDANSK	H7001
1060705	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:55:00+02:00	70	89	13	4.0	54.51	18.75	7.2	222.1	215	GDANSK	H7001
1060706	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:54:00+02:00	70	89	13	4.0	54.51	18.76	7.2	221.2	215	GDANSK	H7001
1060707	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:53:00+02:00	70	89	13	4.0	54.51	18.76	7.2	221.0	214	GDANSK	H7001

Most frequently occurring

	TripID	StartLatitude	StartLongitude	StartTime	EndLatitude	EndLongitude	EndTime	StartPort	EndPort	time	shiptype	Length	Breadth	Draught	Latitude	Longitude	SOG	COG	TH	Destination	AisSourcen	# duplicates
457	5944	54.36	10.14	'2016-08-08 04:10'	54.52	18.52	'2016-08-09 12:31'	KIEL	GDYNIA	2016-08-08 13:48:00+02:00	70	82	12	5.3	54.47	12.24	11.4	29.5	27	GDYNIA.VIA.NOK	71a.H7001	6
681	5944	54.36	10.14	'2016-08-08 04:10'	54.52	18.52	'2016-08-09 12:31'	KIEL	GDYNIA	2016-08-08 17:33:00+02:00	70	82	12	5.3	54.69	13.31	10.8	74.4	75	GDYNIA.VIA.NOK	71a	6
19144	312802	53.58	8.53	'2016-07-15 19:02'	53.52	9.92	'2016-07-16 04:45'	BREMERHAVEN	HAMBURG	2016-07-16 00:31:00+02:00	71	125	22	7.0	53.99	8.18	10.3	90.0	91	HAMBURG	71a.DAIS3.H7001.81b	6
19723	312803	53.58	8.53	'2016-07-15 19:02'	53.52	9.92	'2016-07-16 04:45'	BREMERHAVEN	HAMBURG	2016-07-16 00:31:00+02:00	71	125	22	7.0	53.99	8.18	10.3	90.0	91	HAMBURG	71a.DAIS3.H7001.81b	6
20302	312804	53.58	8.53	'2016-07-15 19:02'	53.52	9.92	'2016-07-16 04:45'	BREMERHAVEN	HAMBURG	2016-07-16 00:31:00+02:00	71	125	22	7.0	53.99	8.18	10.3	90.0	91	HAMBURG	71a.DAIS3.H7001.81b	6
24139	312889	53.58	8.52	'2016-08-05 13:53'	53.53	9.91	'2016-08-05 22:23'	BREMERHAVEN	HAMBURG	2016-08-05 23:43:00+02:00	71	125	22	6.7	53.55	9.79	12.8	107.0	107	HAMBURG	71a.H7001.81b	6
24649	312890	53.58	8.52	'2016-08-05 13:53'	53.53	9.91	'2016-08-05 22:23'	BREMERHAVEN	HAMBURG	2016-08-05 23:43:00+02:00	71	125	22	6.7	53.55	9.79	12.8	107.0	107	HAMBURG	71a.H7001.81b	6
25159	312891	53.58	8.52	'2016-08-05 13:53'	53.53	9.91	'2016-08-05 22:23'	BREMERHAVEN	HAMBURG	2016-08-05 23:43:00+02:00	71	125	22	6.7	53.55	9.79	12.8	107.0	107	HAMBURG	71a.H7001.81b	6
25578	312946	53.58	8.52	'2016-08-19 14:55'	53.53	9.91	'2016-08-20 00:10'	BREMERHAVEN	HAMBURG	2016-08-19 23:15:00+02:00	71	125	22	6.4	53.86	9.27	12.5	115.0	116	DEHAM	51.71a.H7001.81b	6
26125	312947	53.58	8.52	'2016-08-19 14:55'	53.53	9.91	'2016-08-20 00:10'	BREMERHAVEN	HAMBURG	2016-08-19 23:15:00+02:00	71	125	22	6.4	53.86	9.27	12.5	115.0	116	DEHAM	51.71a.H7001.81b	6

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring